# -*- coding: utf-8 -*-
# @Author: Cursor
# @Date: 2025-01-07
# @Last Modified by: Tim Liu
# @Last Modified time: 2024-01-07

# @Description: Ontology and OSchema association 

from sqlalchemy import Table, Column, Integer, ForeignKey
from db.db_base import BaseModel

ontology_schema_association = Table(
    'crewplus_ontology_schema_association',
    BaseModel.metadata,
    Column('ontology_id', Integer, ForeignKey('crewplus_ontology.id', ondelete='CASCADE'), primary_key=True),
    Column('schema_id', Integer, ForeignKey('crewplus_oschema.id', ondelete='CASCADE'), primary_key=True)
)
